The theory presented in the previous 2 posts in this series has been incorporated into an Excel UDF, allowing concrete and reinforcement stresses and strains to be evaluated quickly and easily for reinforced and prestressed members of complex cross-section, subject to combined bending and axial load.
The Excel file also includes UDFs for solution of polynomial equations up to quartic, and routines for plotting the cross section shape.
Beam Design Functions Download
Newton Excel Bach, not (just) an Excel Blog 
New version uploaded 31 MAy 2008. Plot routine amended to work with Excel 2000 to 2003.
LikeLike
New version uploaded 5th June 2008:
A reference to PerfMonitor.dll was causing problems on machines that did not have this installed.
The reference has been removed, and a startup routine added to check that all remaining referenced dlls are present.
LikeLike
Pingback: Reinforced Concrete Section Analysis - 4 « Newton Excel Bach, not (just) an Excel Blog
Pingback: Reinforced Concrete Section Analysis – with prestress « Newton Excel Bach, not (just) an Excel Blog
please mail me
LikeLike
Pingback: Reinforced Concrete Moment-Curvature – 1 « Newton Excel Bach, not (just) an Excel Blog
Pingback: Reinforced concrete elastic analysis; Circular section « Newton Excel Bach, not (just) an Excel Blog
Pingback: Composite Beam Spreadsheet – 2 | Newton Excel Bach, not (just) an Excel Blog